package com.example.demo.mapper;

import java.util.Date;
import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import com.example.demo.entity.Competition;

@Mapper
@Repository
public interface CompetitionMapper {
	//查找全部
	List<Competition> getAllCompetitionInfo(); 
	
	//新建赛事
    int newCompetition(String OrganizersName,String CompetitionName,String CompetitionType,
    		String CompetitionDate,String CompetitionPrice,String CompetitionRemarks,String CompetitionStatus,String CreateTime);      

    //按日期查找
    List<Competition> queryByDate(Date StartTime,Date EndTime);      
    
    //删除赛事
    void deleteCompetition(String OrganizersName,String CompetitionName,String CompetitionType,String CompetitionDate);        
}
